Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

Guidelines for using the DataServer

OpenEdge database management system supports many capabilities not found in other database management systems, such as backward scrolling cursors and the ability to find the previous or last record in a table. The DataServer supports these and other programming and database features to ensure that your applications work with both OpenEdge databases and SQL Server databases.

The DataServer allows you to use Progress 4GL features as extensions to your data source. Some of the Progress programming and OpenEdge database design techniques that you can implement on your MSS data source using the DataServer are:

ROWID function
Arrays

For access to some of these features, you might have to make minor modifications to how your MSS data-source or application is organized. For a discussion of these issues and instructions for modifying your data source, see Chapter 2, " Initial Programming Considerations."

If you create an MSS data-source from an existing OpenEdge database with the Progress-to-MSS migration utility and select the Create RECID Field option, you can use the FIND PREV/LAST statements in addition to taking advantage of Progress-like cursor behavior.

How you use the DataServer depends on whether you plan to access information in a data source through an OpenEdge application or migrate an OpenEdge database to an MSS data source. The following sections summarize what you must do and point you to the information you need in this manual.